CREATE TABLE CRST_GL_PERIOD_STATUSES
(
APPLICATION_ID                NUMBER (15) ,
SET_OF_BOOKS_ID               NUMBER (15) ,
PERIOD_NAME                   VARCHAR (15) ,
LAST_UPDATE_DATE              DATE ,
LAST_UPDATED_BY               NUMBER (15) ,
CLOSING_STATUS                VARCHAR (1) ,
START_DATE                    DATE ,
END_DATE                      DATE ,
YEAR_START_DATE               DATE ,
QUARTER_NUM                   NUMBER (15) ,
QUARTER_START_DATE            DATE ,
PERIOD_TYPE                   VARCHAR (15) ,
PERIOD_YEAR                   NUMBER (15) ,
EFFECTIVE_PERIOD_NUM          NUMBER (15) ,
PERIOD_NUM                    NUMBER (15) ,
ADJUSTMENT_PERIOD_FLAG        VARCHAR (1) ,
CREATION_DATE                 DATE ,
CREATED_BY                    NUMBER (15) ,
LAST_UPDATE_LOGIN             NUMBER (15) ,
ELIMINATION_CONFIRMED_FLAG    VARCHAR (1) ,
ATTRIBUTE1                    VARCHAR (150) ,
ATTRIBUTE2                    VARCHAR (150) ,
ATTRIBUTE3                    VARCHAR (150) ,
ATTRIBUTE4                    VARCHAR (150) ,
ATTRIBUTE5                    VARCHAR (150) ,
CONTEXT                       VARCHAR (150) ,
CHRONOLOGICAL_SEQ_STATUS_CODE VARCHAR (1) 
);
